package com.julian.warehouse.database;

/**
 * Created by Administrator on 2018/8/8.
 */

public  class RecordsTable {
    public static final String TBL_NAME = "RECORDS";
    public static final String COL_ID = "ID";
    public static final String COL_GNAME = "GNAME";
    public static final String COL_CTIME = "CTIME";
    public static final String COL_COUNT = "COUNT";
    public static final String COL_FLAG = "FLAG";
    public static final String COL_RESULT = "RESULT";



    public static String getCreatRecordsTableSQL() {
        String sql = "CREATE TABLE IF NOT EXISTS "
                + TBL_NAME + "(" + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                + COL_GNAME + " VARCHAR(200),"
                + COL_CTIME + " VARCHAR(50),"
                + COL_COUNT + " INTEGER,"
                + COL_FLAG + " INTEGER,"
                + COL_RESULT + " VARCHAR(50)"
                + ")";
        return sql;
    }
}